how to export aws rds data to local

1. install postgresql

   https://www.postgresql.org/download/linux/redhat/

2. backup and restore

   pg_dump -h amazonaws.com -U aws -d database -f database.sql
   
   create user aws with password aws;
   create database database owner aws;
   grant all on database database to aws;
   
   psql -h localhost -U aws -d database -f database.sql
   

3. references:

https://stackoverflow.com/questions/10352695/grant-all-on-a-specific-schema-in-the-db-to-a-group-role-in-postgresql